5 Reporting on the authentication database
The AuthenticationAudits table in the MyID authentication database contains audited information on any attempts to use the MyID authentication service.
You can use the information in this table to generate reports on the authentication activities of your system.
The AuthenticationAudits table has the following format:
|
Field |
Format |
Description |
|---|---|---|
|
Id |
int |
Automatically incrementing primary key field. |
|
LogonMechanism |
nvarchar(20) |
The type of credential used for the logon attempt; for example:
|
|
UserAccountId |
int |
The user account relating to the user attempting to log on. This is the UserAccounts.ID field in the main MyID database. |
|
UserAccountObjectId |
uniqueidentifier |
The user account relating to the user attempting to log on. This is the UserAccounts.ObjectID field in the main MyID database. |
|
DeviceId |
int |
The device relating to the device being used to log on. This is the Devices.ID field in the main MyID database. |
|
DeviceTypeName |
nvarchar(50) |
The device type name relating to the device being used to log on. This is the Devices.DeviceTypeName field in the main MyID database. |
|
DeviceSerialNumber |
nvarchar(50) |
The device serial number relating to the device being used to log on. This is the Devices.SerialNumber field in the main MyID database. |
|
LogonDate |
datetime |
The date and time that this attempt was recorded. |
|
Status |
nvarchar(20) |
The status of this logon attempt; for example:
|
|
ReadableMessage |
nvarchar(max) |
For failed attempts to log on, this contains extra information that you can use to diagnose why a logon failed. Error codes are included in this information; see the MyID Operator Client error codes section in the Error Code Reference guide. |
|
LogonName |
nvarchar(256) |
The logon name of the user attempting to log on. This is the UserAccounts.LogonName field in the main MyID database. |
|
ClientId |
nvarchar(100) |
The OAuth client Id in use; for example:
|